﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="StoredProcedures" targetNamespace="http://tempuri.org/StoredProcedures.xsd" xmlns:mstns="http://tempuri.org/StoredProcedures.xsd" xmlns="http://tempuri.org/StoredProcedures.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="TravConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TravConnectionString (MySettings)" PropertyReference="ApplicationSettings.AdminPanel.My.MySettings.GlobalReference.Default.TravConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_Ally_StatsTableAdapter" GeneratorDataComponentClassName="Get_Ally_StatsTableAdapter" Name="Get_Ally_Stats" UserDataComponentName="Get_Ally_StatsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Ally_Stats" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Ally_Stats</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Ally" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Members" DataSetColumn="Members" />
              <Mapping SourceColumn="Pop" DataSetColumn="Pop" />
              <Mapping SourceColumn="Top" DataSetColumn="Top" />
              <Mapping SourceColumn="Min" DataSetColumn="Min" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_CommandsTableAdapter" GeneratorDataComponentClassName="Get_CommandsTableAdapter" Name="Get_Commands" UserDataComponentName="Get_CommandsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Commands" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Commands</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Accesslvl" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Command_id" DataSetColumn="Command_id" />
              <Mapping SourceColumn="Command_Name" DataSetColumn="Command_Name" />
              <Mapping SourceColumn="Access_lvl" DataSetColumn="Access_lvl" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_MemberTableAdapter" GeneratorDataComponentClassName="Get_MemberTableAdapter" Name="Get_Member" UserDataComponentName="Get_MemberTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Member" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Member</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Member" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PID" DataSetColumn="PID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Tribe" DataSetColumn="Tribe" />
              <Mapping SourceColumn="Pop" DataSetColumn="Pop" />
              <Mapping SourceColumn="Alliance" DataSetColumn="Alliance" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_MembersTableAdapter" GeneratorDataComponentClassName="Get_MembersTableAdapter" Name="Get_Members" UserDataComponentName="Get_MembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Members" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Members</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Alliance" Precision="255" ProviderType="Char" Scale="255" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PID" DataSetColumn="PID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Tribe" DataSetColumn="Tribe" />
              <Mapping SourceColumn="Pop" DataSetColumn="Pop" />
              <Mapping SourceColumn="Alliance" DataSetColumn="Alliance" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_RaceTableAdapter" GeneratorDataComponentClassName="Get_RaceTableAdapter" Name="Get_Race" UserDataComponentName="Get_RaceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Race" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Race</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tid" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Race_Name" DataSetColumn="Race_Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_RacesTableAdapter" GeneratorDataComponentClassName="Get_RacesTableAdapter" Name="Get_Races" UserDataComponentName="Get_RacesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Races" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Races</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Race_id" DataSetColumn="Race_id" />
              <Mapping SourceColumn="Race_name" DataSetColumn="Race_name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_StoredProceduresTableAdapter" GeneratorDataComponentClassName="Get_StoredProceduresTableAdapter" Name="Get_StoredProcedures" UserDataComponentName="Get_StoredProceduresTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_StoredProcedures" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_StoredProcedures</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="xtype" DataSetColumn="xtype" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="info" DataSetColumn="info" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="base_schema_ver" DataSetColumn="base_schema_ver" />
              <Mapping SourceColumn="replinfo" DataSetColumn="replinfo" />
              <Mapping SourceColumn="parent_obj" DataSetColumn="parent_obj" />
              <Mapping SourceColumn="crdate" DataSetColumn="crdate" />
              <Mapping SourceColumn="ftcatid" DataSetColumn="ftcatid" />
              <Mapping SourceColumn="schema_ver" DataSetColumn="schema_ver" />
              <Mapping SourceColumn="stats_schema_ver" DataSetColumn="stats_schema_ver" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="userstat" DataSetColumn="userstat" />
              <Mapping SourceColumn="sysstat" DataSetColumn="sysstat" />
              <Mapping SourceColumn="indexdel" DataSetColumn="indexdel" />
              <Mapping SourceColumn="refdate" DataSetColumn="refdate" />
              <Mapping SourceColumn="version" DataSetColumn="version" />
              <Mapping SourceColumn="deltrig" DataSetColumn="deltrig" />
              <Mapping SourceColumn="instrig" DataSetColumn="instrig" />
              <Mapping SourceColumn="updtrig" DataSetColumn="updtrig" />
              <Mapping SourceColumn="seltrig" DataSetColumn="seltrig" />
              <Mapping SourceColumn="category" DataSetColumn="category" />
              <Mapping SourceColumn="cache" DataSetColumn="cache" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_UnitsTableAdapter" GeneratorDataComponentClassName="Get_UnitsTableAdapter" Name="Get_Units" UserDataComponentName="Get_UnitsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Units" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Units</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Race" Precision="255" ProviderType="Char" Scale="255" Size="11" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Unit_Name" DataSetColumn="Unit_Name" />
              <Mapping SourceColumn="Unit_Speed" DataSetColumn="Unit_Speed" />
              <Mapping SourceColumn="Loot" DataSetColumn="Loot" />
              <Mapping SourceColumn="Funct" DataSetColumn="Funct" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_ViewsTableAdapter" GeneratorDataComponentClassName="Get_ViewsTableAdapter" Name="Get_Views" UserDataComponentName="Get_ViewsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Views" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Views</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="xtype" DataSetColumn="xtype" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="info" DataSetColumn="info" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="base_schema_ver" DataSetColumn="base_schema_ver" />
              <Mapping SourceColumn="replinfo" DataSetColumn="replinfo" />
              <Mapping SourceColumn="parent_obj" DataSetColumn="parent_obj" />
              <Mapping SourceColumn="crdate" DataSetColumn="crdate" />
              <Mapping SourceColumn="ftcatid" DataSetColumn="ftcatid" />
              <Mapping SourceColumn="schema_ver" DataSetColumn="schema_ver" />
              <Mapping SourceColumn="stats_schema_ver" DataSetColumn="stats_schema_ver" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="userstat" DataSetColumn="userstat" />
              <Mapping SourceColumn="sysstat" DataSetColumn="sysstat" />
              <Mapping SourceColumn="indexdel" DataSetColumn="indexdel" />
              <Mapping SourceColumn="refdate" DataSetColumn="refdate" />
              <Mapping SourceColumn="version" DataSetColumn="version" />
              <Mapping SourceColumn="deltrig" DataSetColumn="deltrig" />
              <Mapping SourceColumn="instrig" DataSetColumn="instrig" />
              <Mapping SourceColumn="updtrig" DataSetColumn="updtrig" />
              <Mapping SourceColumn="seltrig" DataSetColumn="seltrig" />
              <Mapping SourceColumn="category" DataSetColumn="category" />
              <Mapping SourceColumn="cache" DataSetColumn="cache" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Get_VillagesTableAdapter" GeneratorDataComponentClassName="Get_VillagesTableAdapter" Name="Get_Villages" UserDataComponentName="Get_VillagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Get_Villages" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Get_Villages</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Player" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="VID" DataSetColumn="VID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Distance" DataSetColumn="Distance" />
              <Mapping SourceColumn="X" DataSetColumn="X" />
              <Mapping SourceColumn="Y" DataSetColumn="Y" />
              <Mapping SourceColumn="Player" DataSetColumn="Player" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Web_CheckIfUserExistsTableAdapter" GeneratorDataComponentClassName="Web_CheckIfUserExistsTableAdapter" Name="Web_CheckIfUserExists" UserDataComponentName="Web_CheckIfUserExistsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Web_CheckIfUserExists" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Web_CheckIfUserExists</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UserName" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WebUser_ID" DataSetColumn="WebUser_ID" />
              <Mapping SourceColumn="WebUserName" DataSetColumn="WebUserName" />
              <Mapping SourceColumn="Web_Password" DataSetColumn="Web_Password" />
              <Mapping SourceColumn="Web_Email" DataSetColumn="Web_Email" />
              <Mapping SourceColumn="Web_FullName" DataSetColumn="Web_FullName" />
              <Mapping SourceColumn="Web_Country" DataSetColumn="Web_Country" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Web_GetPasswordTableAdapter" GeneratorDataComponentClassName="Web_GetPasswordTableAdapter" Name="Web_GetPassword" UserDataComponentName="Web_GetPasswordTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Web_GetPassword" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Web_GetPassword</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Username" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Web_Password" DataSetColumn="Web_Password" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Command_Delete" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Command_Delete" MethodsParameterType="CLR" Modifier="Public" Name="Command_Delete" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Command_Delete">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.Command_Delete</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Cmd_Name" Precision="255" ProviderType="Char" Scale="255" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Command_Insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Command_Insert" MethodsParameterType="CLR" Modifier="Public" Name="Command_Insert" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="Command_Insert">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.Command_Insert</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Command_Name" Precision="255" ProviderType="Char" Scale="255" Size="12" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Access_lvl" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Populate_Members" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Populate_Members" MethodsParameterType="CLR" Modifier="Public" Name="Populate_Members" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="Populate_Members">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.Populate_Members</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Alliance" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Update_Priveleged_Member" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Update_Priveleged_Member" MethodsParameterType="CLR" Modifier="Public" Name="Update_Priveleged_Member" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="Update_Priveleged_Member">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.Update_Priveleged_Member</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Access_lvl" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Name" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TravConnectionString (MySettings)" DbObjectName="Travian.dbo.Web_RegisterUser" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Web_RegisterUser" MethodsParameterType="CLR" Modifier="Public" Name="Web_RegisterUser" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="Web_RegisterUser">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                <CommandText>dbo.Web_RegisterUser</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Integer" Scale="255" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@UserName" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Password" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Email" Precision="255" ProviderType="Char" Scale="255" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@FullName" Precision="255" ProviderType="Char" Scale="255" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Country" Precision="255" ProviderType="Char" Scale="255" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="StoredProcedures" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="StoredProcedures" msprop:Generator_UserDSName="StoredProcedures">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Get_Ally_Stats" msprop:Generator_TableClassName="Get_Ally_StatsDataTable" msprop:Generator_TableVarName="tableGet_Ally_Stats" msprop:Generator_TablePropName="Get_Ally_Stats" msprop:Generator_RowDeletingName="Get_Ally_StatsRowDeleting" msprop:Generator_UserTableName="Get_Ally_Stats" msprop:Generator_RowChangingName="Get_Ally_StatsRowChanging" msprop:Generator_RowEvHandlerName="Get_Ally_StatsRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_Ally_StatsRowDeleted" msprop:Generator_RowEvArgName="Get_Ally_StatsRowChangeEvent" msprop:Generator_RowChangedName="Get_Ally_StatsRowChanged" msprop:Generator_RowClassName="Get_Ally_StatsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Members" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMembers" msprop:Generator_ColumnPropNameInRow="Members" msprop:Generator_ColumnPropNameInTable="MembersColumn" msprop:Generator_UserColumnName="Members" type="xs:int" minOccurs="0" />
              <xs:element name="Pop" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPop" msprop:Generator_ColumnPropNameInRow="Pop" msprop:Generator_ColumnPropNameInTable="PopColumn" msprop:Generator_UserColumnName="Pop" type="xs:int" minOccurs="0" />
              <xs:element name="Top" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTop" msprop:Generator_ColumnPropNameInRow="Top" msprop:Generator_ColumnPropNameInTable="TopColumn" msprop:Generator_UserColumnName="Top" type="xs:int" minOccurs="0" />
              <xs:element name="Min" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMin" msprop:Generator_ColumnPropNameInRow="Min" msprop:Generator_ColumnPropNameInTable="MinColumn" msprop:Generator_UserColumnName="Min" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Commands" msprop:Generator_TableClassName="Get_CommandsDataTable" msprop:Generator_TableVarName="tableGet_Commands" msprop:Generator_TablePropName="Get_Commands" msprop:Generator_RowDeletingName="Get_CommandsRowDeleting" msprop:Generator_UserTableName="Get_Commands" msprop:Generator_RowChangingName="Get_CommandsRowChanging" msprop:Generator_RowEvHandlerName="Get_CommandsRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_CommandsRowDeleted" msprop:Generator_RowEvArgName="Get_CommandsRowChangeEvent" msprop:Generator_RowChangedName="Get_CommandsRowChanged" msprop:Generator_RowClassName="Get_CommandsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Command_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnCommand_id" msprop:Generator_ColumnPropNameInRow="Command_id" msprop:Generator_ColumnPropNameInTable="Command_idColumn" msprop:Generator_UserColumnName="Command_id" type="xs:int" />
              <xs:element name="Command_Name" msprop:Generator_ColumnVarNameInTable="columnCommand_Name" msprop:Generator_ColumnPropNameInRow="Command_Name" msprop:Generator_ColumnPropNameInTable="Command_NameColumn" msprop:Generator_UserColumnName="Command_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Access_lvl" msprop:Generator_ColumnVarNameInTable="columnAccess_lvl" msprop:Generator_ColumnPropNameInRow="Access_lvl" msprop:Generator_ColumnPropNameInTable="Access_lvlColumn" msprop:Generator_UserColumnName="Access_lvl" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Member" msprop:Generator_TableClassName="Get_MemberDataTable" msprop:Generator_TableVarName="tableGet_Member" msprop:Generator_TablePropName="Get_Member" msprop:Generator_RowDeletingName="Get_MemberRowDeleting" msprop:Generator_UserTableName="Get_Member" msprop:Generator_RowChangingName="Get_MemberRowChanging" msprop:Generator_RowEvHandlerName="Get_MemberRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_MemberRowDeleted" msprop:Generator_RowEvArgName="Get_MemberRowChangeEvent" msprop:Generator_RowChangedName="Get_MemberRowChanged" msprop:Generator_RowClassName="Get_MemberRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PID" msprop:Generator_ColumnVarNameInTable="columnPID" msprop:Generator_ColumnPropNameInRow="PID" msprop:Generator_ColumnPropNameInTable="PIDColumn" msprop:Generator_UserColumnName="PID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tribe" msprop:Generator_ColumnVarNameInTable="columnTribe" msprop:Generator_ColumnPropNameInRow="Tribe" msprop:Generator_ColumnPropNameInTable="TribeColumn" msprop:Generator_UserColumnName="Tribe" type="xs:int" />
              <xs:element name="Pop" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPop" msprop:Generator_ColumnPropNameInRow="Pop" msprop:Generator_ColumnPropNameInTable="PopColumn" msprop:Generator_UserColumnName="Pop" type="xs:int" minOccurs="0" />
              <xs:element name="Alliance" msprop:Generator_ColumnVarNameInTable="columnAlliance" msprop:Generator_ColumnPropNameInRow="Alliance" msprop:Generator_ColumnPropNameInTable="AllianceColumn" msprop:Generator_UserColumnName="Alliance">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Members" msprop:Generator_TableClassName="Get_MembersDataTable" msprop:Generator_TableVarName="tableGet_Members" msprop:Generator_TablePropName="Get_Members" msprop:Generator_RowDeletingName="Get_MembersRowDeleting" msprop:Generator_UserTableName="Get_Members" msprop:Generator_RowChangingName="Get_MembersRowChanging" msprop:Generator_RowEvHandlerName="Get_MembersRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_MembersRowDeleted" msprop:Generator_RowEvArgName="Get_MembersRowChangeEvent" msprop:Generator_RowChangedName="Get_MembersRowChanged" msprop:Generator_RowClassName="Get_MembersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PID" msprop:Generator_ColumnVarNameInTable="columnPID" msprop:Generator_ColumnPropNameInRow="PID" msprop:Generator_ColumnPropNameInTable="PIDColumn" msprop:Generator_UserColumnName="PID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tribe" msprop:Generator_ColumnVarNameInTable="columnTribe" msprop:Generator_ColumnPropNameInRow="Tribe" msprop:Generator_ColumnPropNameInTable="TribeColumn" msprop:Generator_UserColumnName="Tribe" type="xs:int" />
              <xs:element name="Pop" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPop" msprop:Generator_ColumnPropNameInRow="Pop" msprop:Generator_ColumnPropNameInTable="PopColumn" msprop:Generator_UserColumnName="Pop" type="xs:int" minOccurs="0" />
              <xs:element name="Alliance" msprop:Generator_ColumnVarNameInTable="columnAlliance" msprop:Generator_ColumnPropNameInRow="Alliance" msprop:Generator_ColumnPropNameInTable="AllianceColumn" msprop:Generator_UserColumnName="Alliance">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Race" msprop:Generator_TableClassName="Get_RaceDataTable" msprop:Generator_TableVarName="tableGet_Race" msprop:Generator_TablePropName="Get_Race" msprop:Generator_RowDeletingName="Get_RaceRowDeleting" msprop:Generator_UserTableName="Get_Race" msprop:Generator_RowChangingName="Get_RaceRowChanging" msprop:Generator_RowEvHandlerName="Get_RaceRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_RaceRowDeleted" msprop:Generator_RowEvArgName="Get_RaceRowChangeEvent" msprop:Generator_RowChangedName="Get_RaceRowChanged" msprop:Generator_RowClassName="Get_RaceRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Race_Name" msprop:Generator_ColumnVarNameInTable="columnRace_Name" msprop:Generator_ColumnPropNameInRow="Race_Name" msprop:Generator_ColumnPropNameInTable="Race_NameColumn" msprop:Generator_UserColumnName="Race_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Races" msprop:Generator_TableClassName="Get_RacesDataTable" msprop:Generator_TableVarName="tableGet_Races" msprop:Generator_TablePropName="Get_Races" msprop:Generator_RowDeletingName="Get_RacesRowDeleting" msprop:Generator_UserTableName="Get_Races" msprop:Generator_RowChangingName="Get_RacesRowChanging" msprop:Generator_RowEvHandlerName="Get_RacesRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_RacesRowDeleted" msprop:Generator_RowEvArgName="Get_RacesRowChangeEvent" msprop:Generator_RowChangedName="Get_RacesRowChanged" msprop:Generator_RowClassName="Get_RacesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Race_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnRace_id" msprop:Generator_ColumnPropNameInRow="Race_id" msprop:Generator_ColumnPropNameInTable="Race_idColumn" msprop:Generator_UserColumnName="Race_id" type="xs:int" />
              <xs:element name="Race_name" msprop:Generator_ColumnVarNameInTable="columnRace_name" msprop:Generator_ColumnPropNameInRow="Race_name" msprop:Generator_ColumnPropNameInTable="Race_nameColumn" msprop:Generator_UserColumnName="Race_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_StoredProcedures" msprop:Generator_TableClassName="Get_StoredProceduresDataTable" msprop:Generator_TableVarName="tableGet_StoredProcedures" msprop:Generator_TablePropName="Get_StoredProcedures" msprop:Generator_RowDeletingName="Get_StoredProceduresRowDeleting" msprop:Generator_UserTableName="Get_StoredProcedures" msprop:Generator_RowChangingName="Get_StoredProceduresRowChanging" msprop:Generator_RowEvHandlerName="Get_StoredProceduresRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_StoredProceduresRowDeleted" msprop:Generator_RowEvArgName="Get_StoredProceduresRowChangeEvent" msprop:Generator_RowChangedName="Get_StoredProceduresRowChanged" msprop:Generator_RowClassName="Get_StoredProceduresRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="xtype" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnxtype" msprop:Generator_ColumnPropNameInRow="xtype" msprop:Generator_ColumnPropNameInTable="xtypeColumn" msprop:Generator_UserColumnName="xtype" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:short" minOccurs="0" />
              <xs:element name="info" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columninfo" msprop:Generator_ColumnPropNameInRow="info" msprop:Generator_ColumnPropNameInTable="infoColumn" msprop:Generator_UserColumnName="info" type="xs:short" minOccurs="0" />
              <xs:element name="status" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" type="xs:int" minOccurs="0" />
              <xs:element name="base_schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnbase_schema_ver" msprop:Generator_ColumnPropNameInRow="base_schema_ver" msprop:Generator_ColumnPropNameInTable="base_schema_verColumn" msprop:Generator_UserColumnName="base_schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="replinfo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnreplinfo" msprop:Generator_ColumnPropNameInRow="replinfo" msprop:Generator_ColumnPropNameInTable="replinfoColumn" msprop:Generator_UserColumnName="replinfo" type="xs:int" minOccurs="0" />
              <xs:element name="parent_obj" msprop:Generator_ColumnVarNameInTable="columnparent_obj" msprop:Generator_ColumnPropNameInRow="parent_obj" msprop:Generator_ColumnPropNameInTable="parent_objColumn" msprop:Generator_UserColumnName="parent_obj" type="xs:int" />
              <xs:element name="crdate" msprop:Generator_ColumnVarNameInTable="columncrdate" msprop:Generator_ColumnPropNameInRow="crdate" msprop:Generator_ColumnPropNameInTable="crdateColumn" msprop:Generator_UserColumnName="crdate" type="xs:dateTime" />
              <xs:element name="ftcatid" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnftcatid" msprop:Generator_ColumnPropNameInRow="ftcatid" msprop:Generator_ColumnPropNameInTable="ftcatidColumn" msprop:Generator_UserColumnName="ftcatid" type="xs:short" minOccurs="0" />
              <xs:element name="schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnschema_ver" msprop:Generator_ColumnPropNameInRow="schema_ver" msprop:Generator_ColumnPropNameInTable="schema_verColumn" msprop:Generator_UserColumnName="schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="stats_schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnstats_schema_ver" msprop:Generator_ColumnPropNameInRow="stats_schema_ver" msprop:Generator_ColumnPropNameInTable="stats_schema_verColumn" msprop:Generator_UserColumnName="stats_schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="type" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="userstat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnuserstat" msprop:Generator_ColumnPropNameInRow="userstat" msprop:Generator_ColumnPropNameInTable="userstatColumn" msprop:Generator_UserColumnName="userstat" type="xs:short" minOccurs="0" />
              <xs:element name="sysstat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsysstat" msprop:Generator_ColumnPropNameInRow="sysstat" msprop:Generator_ColumnPropNameInTable="sysstatColumn" msprop:Generator_UserColumnName="sysstat" type="xs:short" minOccurs="0" />
              <xs:element name="indexdel" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnindexdel" msprop:Generator_ColumnPropNameInRow="indexdel" msprop:Generator_ColumnPropNameInTable="indexdelColumn" msprop:Generator_UserColumnName="indexdel" type="xs:short" minOccurs="0" />
              <xs:element name="refdate" msprop:Generator_ColumnVarNameInTable="columnrefdate" msprop:Generator_ColumnPropNameInRow="refdate" msprop:Generator_ColumnPropNameInTable="refdateColumn" msprop:Generator_UserColumnName="refdate" type="xs:dateTime" />
              <xs:element name="version" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnversion" msprop:Generator_ColumnPropNameInRow="version" msprop:Generator_ColumnPropNameInTable="versionColumn" msprop:Generator_UserColumnName="version" type="xs:int" minOccurs="0" />
              <xs:element name="deltrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndeltrig" msprop:Generator_ColumnPropNameInRow="deltrig" msprop:Generator_ColumnPropNameInTable="deltrigColumn" msprop:Generator_UserColumnName="deltrig" type="xs:int" minOccurs="0" />
              <xs:element name="instrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columninstrig" msprop:Generator_ColumnPropNameInRow="instrig" msprop:Generator_ColumnPropNameInTable="instrigColumn" msprop:Generator_UserColumnName="instrig" type="xs:int" minOccurs="0" />
              <xs:element name="updtrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnupdtrig" msprop:Generator_ColumnPropNameInRow="updtrig" msprop:Generator_ColumnPropNameInTable="updtrigColumn" msprop:Generator_UserColumnName="updtrig" type="xs:int" minOccurs="0" />
              <xs:element name="seltrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnseltrig" msprop:Generator_ColumnPropNameInRow="seltrig" msprop:Generator_ColumnPropNameInTable="seltrigColumn" msprop:Generator_UserColumnName="seltrig" type="xs:int" minOccurs="0" />
              <xs:element name="category" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncategory" msprop:Generator_ColumnPropNameInRow="category" msprop:Generator_ColumnPropNameInTable="categoryColumn" msprop:Generator_UserColumnName="category" type="xs:int" minOccurs="0" />
              <xs:element name="cache" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncache" msprop:Generator_ColumnPropNameInRow="cache" msprop:Generator_ColumnPropNameInTable="cacheColumn" msprop:Generator_UserColumnName="cache" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Units" msprop:Generator_TableClassName="Get_UnitsDataTable" msprop:Generator_TableVarName="tableGet_Units" msprop:Generator_TablePropName="Get_Units" msprop:Generator_RowDeletingName="Get_UnitsRowDeleting" msprop:Generator_UserTableName="Get_Units" msprop:Generator_RowChangingName="Get_UnitsRowChanging" msprop:Generator_RowEvHandlerName="Get_UnitsRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_UnitsRowDeleted" msprop:Generator_RowEvArgName="Get_UnitsRowChangeEvent" msprop:Generator_RowChangedName="Get_UnitsRowChanged" msprop:Generator_RowClassName="Get_UnitsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Unit_Name" msprop:Generator_ColumnVarNameInTable="columnUnit_Name" msprop:Generator_ColumnPropNameInRow="Unit_Name" msprop:Generator_ColumnPropNameInTable="Unit_NameColumn" msprop:Generator_UserColumnName="Unit_Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Unit_Speed" msprop:Generator_ColumnVarNameInTable="columnUnit_Speed" msprop:Generator_ColumnPropNameInRow="Unit_Speed" msprop:Generator_ColumnPropNameInTable="Unit_SpeedColumn" msprop:Generator_UserColumnName="Unit_Speed" type="xs:int" />
              <xs:element name="Loot" msprop:Generator_ColumnVarNameInTable="columnLoot" msprop:Generator_ColumnPropNameInRow="Loot" msprop:Generator_ColumnPropNameInTable="LootColumn" msprop:Generator_UserColumnName="Loot" type="xs:int" />
              <xs:element name="Funct" msprop:Generator_ColumnVarNameInTable="columnFunct" msprop:Generator_ColumnPropNameInRow="Funct" msprop:Generator_ColumnPropNameInTable="FunctColumn" msprop:Generator_UserColumnName="Funct">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Views" msprop:Generator_TableClassName="Get_ViewsDataTable" msprop:Generator_TableVarName="tableGet_Views" msprop:Generator_TablePropName="Get_Views" msprop:Generator_RowDeletingName="Get_ViewsRowDeleting" msprop:Generator_UserTableName="Get_Views" msprop:Generator_RowChangingName="Get_ViewsRowChanging" msprop:Generator_RowEvHandlerName="Get_ViewsRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_ViewsRowDeleted" msprop:Generator_RowEvArgName="Get_ViewsRowChangeEvent" msprop:Generator_RowChangedName="Get_ViewsRowChanged" msprop:Generator_RowClassName="Get_ViewsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="xtype" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnxtype" msprop:Generator_ColumnPropNameInRow="xtype" msprop:Generator_ColumnPropNameInTable="xtypeColumn" msprop:Generator_UserColumnName="xtype" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:short" minOccurs="0" />
              <xs:element name="info" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columninfo" msprop:Generator_ColumnPropNameInRow="info" msprop:Generator_ColumnPropNameInTable="infoColumn" msprop:Generator_UserColumnName="info" type="xs:short" minOccurs="0" />
              <xs:element name="status" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status" type="xs:int" minOccurs="0" />
              <xs:element name="base_schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnbase_schema_ver" msprop:Generator_ColumnPropNameInRow="base_schema_ver" msprop:Generator_ColumnPropNameInTable="base_schema_verColumn" msprop:Generator_UserColumnName="base_schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="replinfo" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnreplinfo" msprop:Generator_ColumnPropNameInRow="replinfo" msprop:Generator_ColumnPropNameInTable="replinfoColumn" msprop:Generator_UserColumnName="replinfo" type="xs:int" minOccurs="0" />
              <xs:element name="parent_obj" msprop:Generator_ColumnVarNameInTable="columnparent_obj" msprop:Generator_ColumnPropNameInRow="parent_obj" msprop:Generator_ColumnPropNameInTable="parent_objColumn" msprop:Generator_UserColumnName="parent_obj" type="xs:int" />
              <xs:element name="crdate" msprop:Generator_ColumnVarNameInTable="columncrdate" msprop:Generator_ColumnPropNameInRow="crdate" msprop:Generator_ColumnPropNameInTable="crdateColumn" msprop:Generator_UserColumnName="crdate" type="xs:dateTime" />
              <xs:element name="ftcatid" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnftcatid" msprop:Generator_ColumnPropNameInRow="ftcatid" msprop:Generator_ColumnPropNameInTable="ftcatidColumn" msprop:Generator_UserColumnName="ftcatid" type="xs:short" minOccurs="0" />
              <xs:element name="schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnschema_ver" msprop:Generator_ColumnPropNameInRow="schema_ver" msprop:Generator_ColumnPropNameInTable="schema_verColumn" msprop:Generator_UserColumnName="schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="stats_schema_ver" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnstats_schema_ver" msprop:Generator_ColumnPropNameInRow="stats_schema_ver" msprop:Generator_ColumnPropNameInTable="stats_schema_verColumn" msprop:Generator_UserColumnName="stats_schema_ver" type="xs:int" minOccurs="0" />
              <xs:element name="type" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="userstat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnuserstat" msprop:Generator_ColumnPropNameInRow="userstat" msprop:Generator_ColumnPropNameInTable="userstatColumn" msprop:Generator_UserColumnName="userstat" type="xs:short" minOccurs="0" />
              <xs:element name="sysstat" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsysstat" msprop:Generator_ColumnPropNameInRow="sysstat" msprop:Generator_ColumnPropNameInTable="sysstatColumn" msprop:Generator_UserColumnName="sysstat" type="xs:short" minOccurs="0" />
              <xs:element name="indexdel" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnindexdel" msprop:Generator_ColumnPropNameInRow="indexdel" msprop:Generator_ColumnPropNameInTable="indexdelColumn" msprop:Generator_UserColumnName="indexdel" type="xs:short" minOccurs="0" />
              <xs:element name="refdate" msprop:Generator_ColumnVarNameInTable="columnrefdate" msprop:Generator_ColumnPropNameInRow="refdate" msprop:Generator_ColumnPropNameInTable="refdateColumn" msprop:Generator_UserColumnName="refdate" type="xs:dateTime" />
              <xs:element name="version" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnversion" msprop:Generator_ColumnPropNameInRow="version" msprop:Generator_ColumnPropNameInTable="versionColumn" msprop:Generator_UserColumnName="version" type="xs:int" minOccurs="0" />
              <xs:element name="deltrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columndeltrig" msprop:Generator_ColumnPropNameInRow="deltrig" msprop:Generator_ColumnPropNameInTable="deltrigColumn" msprop:Generator_UserColumnName="deltrig" type="xs:int" minOccurs="0" />
              <xs:element name="instrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columninstrig" msprop:Generator_ColumnPropNameInRow="instrig" msprop:Generator_ColumnPropNameInTable="instrigColumn" msprop:Generator_UserColumnName="instrig" type="xs:int" minOccurs="0" />
              <xs:element name="updtrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnupdtrig" msprop:Generator_ColumnPropNameInRow="updtrig" msprop:Generator_ColumnPropNameInTable="updtrigColumn" msprop:Generator_UserColumnName="updtrig" type="xs:int" minOccurs="0" />
              <xs:element name="seltrig" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnseltrig" msprop:Generator_ColumnPropNameInRow="seltrig" msprop:Generator_ColumnPropNameInTable="seltrigColumn" msprop:Generator_UserColumnName="seltrig" type="xs:int" minOccurs="0" />
              <xs:element name="category" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncategory" msprop:Generator_ColumnPropNameInRow="category" msprop:Generator_ColumnPropNameInTable="categoryColumn" msprop:Generator_UserColumnName="category" type="xs:int" minOccurs="0" />
              <xs:element name="cache" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columncache" msprop:Generator_ColumnPropNameInRow="cache" msprop:Generator_ColumnPropNameInTable="cacheColumn" msprop:Generator_UserColumnName="cache" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Get_Villages" msprop:Generator_TableClassName="Get_VillagesDataTable" msprop:Generator_TableVarName="tableGet_Villages" msprop:Generator_TablePropName="Get_Villages" msprop:Generator_RowDeletingName="Get_VillagesRowDeleting" msprop:Generator_UserTableName="Get_Villages" msprop:Generator_RowChangingName="Get_VillagesRowChanging" msprop:Generator_RowEvHandlerName="Get_VillagesRowChangeEventHandler" msprop:Generator_RowDeletedName="Get_VillagesRowDeleted" msprop:Generator_RowEvArgName="Get_VillagesRowChangeEvent" msprop:Generator_RowChangedName="Get_VillagesRowChanged" msprop:Generator_RowClassName="Get_VillagesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="VID" msprop:Generator_ColumnVarNameInTable="columnVID" msprop:Generator_ColumnPropNameInRow="VID" msprop:Generator_ColumnPropNameInTable="VIDColumn" msprop:Generator_UserColumnName="VID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Distance" msprop:Generator_ColumnVarNameInTable="columnDistance" msprop:Generator_ColumnPropNameInRow="Distance" msprop:Generator_ColumnPropNameInTable="DistanceColumn" msprop:Generator_UserColumnName="Distance" type="xs:int" />
              <xs:element name="X" msprop:Generator_ColumnVarNameInTable="columnX" msprop:Generator_ColumnPropNameInRow="X" msprop:Generator_ColumnPropNameInTable="XColumn" msprop:Generator_UserColumnName="X" type="xs:int" />
              <xs:element name="Y" msprop:Generator_ColumnVarNameInTable="columnY" msprop:Generator_ColumnPropNameInRow="Y" msprop:Generator_ColumnPropNameInTable="YColumn" msprop:Generator_UserColumnName="Y" type="xs:int" />
              <xs:element name="Player" msprop:Generator_ColumnVarNameInTable="columnPlayer" msprop:Generator_ColumnPropNameInRow="Player" msprop:Generator_ColumnPropNameInTable="PlayerColumn" msprop:Generator_UserColumnName="Player">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Web_CheckIfUserExists" msprop:Generator_TableClassName="Web_CheckIfUserExistsDataTable" msprop:Generator_TableVarName="tableWeb_CheckIfUserExists" msprop:Generator_TablePropName="Web_CheckIfUserExists" msprop:Generator_RowDeletingName="Web_CheckIfUserExistsRowDeleting" msprop:Generator_UserTableName="Web_CheckIfUserExists" msprop:Generator_RowChangingName="Web_CheckIfUserExistsRowChanging" msprop:Generator_RowEvHandlerName="Web_CheckIfUserExistsRowChangeEventHandler" msprop:Generator_RowDeletedName="Web_CheckIfUserExistsRowDeleted" msprop:Generator_RowEvArgName="Web_CheckIfUserExistsRowChangeEvent" msprop:Generator_RowChangedName="Web_CheckIfUserExistsRowChanged" msprop:Generator_RowClassName="Web_CheckIfUserExistsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WebUser_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnWebUser_ID" msprop:Generator_ColumnPropNameInRow="WebUser_ID" msprop:Generator_ColumnPropNameInTable="WebUser_IDColumn" msprop:Generator_UserColumnName="WebUser_ID" type="xs:int" />
              <xs:element name="WebUserName" msprop:Generator_ColumnVarNameInTable="columnWebUserName" msprop:Generator_ColumnPropNameInRow="WebUserName" msprop:Generator_ColumnPropNameInTable="WebUserNameColumn" msprop:Generator_UserColumnName="WebUserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_Password" msprop:Generator_ColumnVarNameInTable="columnWeb_Password" msprop:Generator_ColumnPropNameInRow="Web_Password" msprop:Generator_ColumnPropNameInTable="Web_PasswordColumn" msprop:Generator_UserColumnName="Web_Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_Email" msprop:Generator_ColumnVarNameInTable="columnWeb_Email" msprop:Generator_ColumnPropNameInRow="Web_Email" msprop:Generator_ColumnPropNameInTable="Web_EmailColumn" msprop:Generator_UserColumnName="Web_Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_FullName" msprop:Generator_ColumnVarNameInTable="columnWeb_FullName" msprop:Generator_ColumnPropNameInRow="Web_FullName" msprop:Generator_ColumnPropNameInTable="Web_FullNameColumn" msprop:Generator_UserColumnName="Web_FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Web_Country" msprop:Generator_ColumnVarNameInTable="columnWeb_Country" msprop:Generator_ColumnPropNameInRow="Web_Country" msprop:Generator_ColumnPropNameInTable="Web_CountryColumn" msprop:Generator_UserColumnName="Web_Country" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Web_GetPassword" msprop:Generator_TableClassName="Web_GetPasswordDataTable" msprop:Generator_TableVarName="tableWeb_GetPassword" msprop:Generator_TablePropName="Web_GetPassword" msprop:Generator_RowDeletingName="Web_GetPasswordRowDeleting" msprop:Generator_UserTableName="Web_GetPassword" msprop:Generator_RowChangingName="Web_GetPasswordRowChanging" msprop:Generator_RowEvHandlerName="Web_GetPasswordRowChangeEventHandler" msprop:Generator_RowDeletedName="Web_GetPasswordRowDeleted" msprop:Generator_RowEvArgName="Web_GetPasswordRowChangeEvent" msprop:Generator_RowChangedName="Web_GetPasswordRowChanged" msprop:Generator_RowClassName="Web_GetPasswordRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Web_Password" msprop:Generator_ColumnVarNameInTable="columnWeb_Password" msprop:Generator_ColumnPropNameInRow="Web_Password" msprop:Generator_ColumnPropNameInTable="Web_PasswordColumn" msprop:Generator_UserColumnName="Web_Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Get_Commands" />
      <xs:field xpath="mstns:Command_id" />
    </xs:unique>
    <xs:unique name="Get_Races_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Get_Races" />
      <xs:field xpath="mstns:Race_id" />
    </xs:unique>
    <xs:unique name="Get_StoredProcedures_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Get_StoredProcedures" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Get_Views_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Get_Views" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Web_CheckIfUserExists_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Web_CheckIfUserExists" />
      <xs:field xpath="mstns:WebUser_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>